Setting up the gpfdist program as a service

You can use the gpfdist program as a service when replicating data to Pivotal Greenplum endpoints using Qlik Replicate. In this way it is assured that a replication task that is running will not lose its connection to gpfdist. This solution is best used when more than one task is using the same gpfdist program.

Note that you can set up Pivotal Greenplum endpoints as described in Setting general connection properties and test it without creating a service, but you should create the service before you begin to work with the Pivotal Greenplum endpoints.

To create use a gpfdist service:

1. From the command-line console on the computer where Qlik Replicate is installed, change the directory to the directory where Qlik Replicate is installed.

2. Type the following at the command-line prompt to create the service.

   repctl service create <name of service (optional)> database=<name of Pivotal Greenplum database>

   Information note

   The Pivotal Greenplum database that you use in this command must be configured in Qlik Replicate. If you have defined more than one Pivotal Greenplum database, you can use any of the database names. All of the defined endpoints on the same Qlik Replicate instance are included in the defined service.

3. Start the service before you run any Pivotal Greenplum tasks by typing the following at the command line prompt:

   sc start AttunityReplicateServer_<name of database you defined the service with>

   Information note

   If you chose to create a data folder in a separate location from where you installed Qlik Replicate, you must add the prefix -d <path to data folder> before any command line task described in this section. For example, to start the service you must type:

   -d <path to data folder> sc start AttunityReplicateServer_<name of database>

   Working with a data folder in a different location is recommended when working with large Pivotal Greenplum endpoints. For more information, see Setting up Qlik Replicate on Windows.

To stop the service:

• Type the following at the command-line prompt:

  sc stop AttunityReplicateServer_<name of database you defined the service with>

To delete the service:

• Type the following at the command-line prompt:

  sc delete AttunityReplicateServer_<name of database you defined the service with>